﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SchoolManagerDataSet" targetNamespace="http://tempuri.org/SchoolManagerDataSet.xsd" xmlns:mstns="http://tempuri.org/SchoolManagerDataSet.xsd" xmlns="http://tempuri.org/SchoolManagerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SchoolManagerConnString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SchoolManagerConnString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.School_Manager.Properties.Settings.GlobalReference.Default.SchoolManagerConnString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentTableAdapter" GeneratorDataComponentClassName="tblAssignmentTableAdapter" Name="tblAssignment" UserDataComponentName="tblAssignmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblAssignment] WHERE (([Assignment] = @Original_Assignment) AND ([Class] = @Original_Class) AND ([Kind] = @Original_Kind) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_DueDate = 1 AND [DueDate] IS NULL) OR ([DueDate] = @Original_DueDate)) AND ([Complete] = @Original_Complete) AND ((@IsNull_Percent = 1 AND [Percent] IS NULL) OR ([Percent] = @Original_Percent)) AND ([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Assignment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kind" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Complete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblAssignment] ([Assignment], [Course], [Kind], [Priority], [StartDate], [DueDate], [Complete], [Percent], [Id]) VALUES (@Assignment, @Course, @Kind, @Priority, @StartDate, @DueDate, @Complete, @Percent, @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Assignment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Course" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Kind" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Complete" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Assignment, Class, Kind, Priority, StartDate, DueDate, Complete, [Percent], Id FROM dbo.tblAssignment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblAssignment] SET [Assignment] = @Assignment, [Class] = @Class, [Kind] = @Kind, [Priority] = @Priority, [StartDate] = @StartDate, [DueDate] = @DueDate, [Complete] = @Complete, [Percent] = @Percent WHERE (([Assignment] = @Original_Assignment) AND ([Class] = @Original_Class) AND ([Kind] = @Original_Kind) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_DueDate = 1 AND [DueDate] IS NULL) OR ([DueDate] = @Original_DueDate)) AND ([Complete] = @Original_Complete) AND ((@IsNull_Percent = 1 AND [Percent] IS NULL) OR ([Percent] = @Original_Percent)) AND ([Id] = @Original_Id));
SELECT Assignment, Class, Kind, Priority, StartDate, DueDate, Complete, [Percent], id FROM tblAssignment WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Assignment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Kind" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Complete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Assignment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kind" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DueDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Complete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Percent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="SchoolManager.dbo.tblAssignment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Assignment" DataSetColumn="Assignment" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
              <Mapping SourceColumn="Percent" DataSetColumn="Percent" />
              <Mapping SourceColumn="Class" DataSetColumn="Class" />
              <Mapping SourceColumn="Kind" DataSetColumn="Kind" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Complete" DataSetColumn="Complete" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Assignment, Class, Kind, DueDate, Complete, [Percent]
FROM         tblAssignment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblInstructorTableAdapter" GeneratorDataComponentClassName="tblInstructorTableAdapter" Name="tblInstructor" UserDataComponentName="tblInstructorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblInstructor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblInstructor] ([LastName], [FirstName], [Email], [PhoneNumber]) VALUES (@LastName, @FirstName, @Email, @PhoneNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhoneNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT LastName, FirstName, Email, PhoneNumber FROM dbo.tblInstructor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="PhoneNumber" DataSetColumn="PhoneNumber" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblGradesTableAdapter" GeneratorDataComponentClassName="tblGradesTableAdapter" Name="tblGrades" UserDataComponentName="tblGradesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblGrades" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblGrades] WHERE (([id] = @Original_id) AND ([Assignment] = @Original_Assignment) AND ((@IsNull_TotalPoints = 1 AND [TotalPoints] IS NULL) OR ([TotalPoints] = @Original_TotalPoints)) AND ((@IsNull_AquiredPoints = 1 AND [AquiredPoints] IS NULL) OR ([AquiredPoints] = @Original_AquiredPoints)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Assignment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AquiredPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblGrades] ([Assignment], [TotalPoints], [AquiredPoints]) VALUES (@Assignment, @TotalPoints, @AquiredPoints);
SELECT id, Assignment, TotalPoints, AquiredPoints FROM tblGrades WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Assignment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Assignment, TotalPoints, AquiredPoints FROM dbo.tblGrades</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblGrades] SET [Assignment] = @Assignment, [TotalPoints] = @TotalPoints, [AquiredPoints] = @AquiredPoints WHERE (([id] = @Original_id) AND ([Assignment] = @Original_Assignment) AND ((@IsNull_TotalPoints = 1 AND [TotalPoints] IS NULL) OR ([TotalPoints] = @Original_TotalPoints)) AND ((@IsNull_AquiredPoints = 1 AND [AquiredPoints] IS NULL) OR ([AquiredPoints] = @Original_AquiredPoints)));
SELECT id, Assignment, TotalPoints, AquiredPoints FROM tblGrades WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Assignment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Assignment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Assignment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AquiredPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Assignment" DataSetColumn="Assignment" />
              <Mapping SourceColumn="TotalPoints" DataSetColumn="TotalPoints" />
              <Mapping SourceColumn="AquiredPoints" DataSetColumn="AquiredPoints" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblKindTableAdapter" GeneratorDataComponentClassName="tblKindTableAdapter" Name="tblKind" UserDataComponentName="tblKindTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblKind" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblKind] WHERE (([id] = @Original_id) AND ([Kind] = @Original_Kind))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Kind" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblKind] ([Kind]) VALUES (@Kind);
SELECT id, Kind FROM tblKind WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kind" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Kind FROM dbo.tblKind</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblKind] SET [Kind] = @Kind WHERE (([id] = @Original_id) AND ([Kind] = @Original_Kind));
SELECT id, Kind FROM tblKind WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kind" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Kind" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kind" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Kind" DataSetColumn="Kind" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPriorityTableAdapter" GeneratorDataComponentClassName="tblPriorityTableAdapter" Name="tblPriority" UserDataComponentName="tblPriorityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblPriority" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblPriority] WHERE (([id] = @Original_id) AND ([Priority] = @Original_Priority))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblPriority] ([Priority]) VALUES (@Priority);
SELECT id, Priority FROM tblPriority WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Priority FROM dbo.tblPriority</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblPriority] SET [Priority] = @Priority WHERE (([id] = @Original_id) AND ([Priority] = @Original_Priority));
SELECT id, Priority FROM tblPriority WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTermTableAdapter" GeneratorDataComponentClassName="tblTermTableAdapter" Name="tblTerm" UserDataComponentName="tblTermTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblTerm" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTerm] WHERE (([id] = @Original_id) AND ([Term] = @Original_Term) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblTerm] ([Term], [StartDate], [EndDate]) VALUES (@Term, @StartDate, @EndDate);
SELECT id, Term, StartDate, EndDate FROM tblTerm WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Term, StartDate, EndDate FROM dbo.tblTerm</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTerm] SET [Term] = @Term, [StartDate] = @StartDate, [EndDate] = @EndDate WHERE (([id] = @Original_id) AND ([Term] = @Original_Term) AND ([StartDate] = @Original_StartDate) AND ([EndDate] = @Original_EndDate));
SELECT id, Term, StartDate, EndDate FROM tblTerm WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Term" DataSetColumn="Term" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblClassTableAdapter" GeneratorDataComponentClassName="tblClassTableAdapter" Name="tblClass" UserDataComponentName="tblClassTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SchoolManagerConnString (Settings)" DbObjectName="SchoolManager.dbo.tblClass" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblClass] WHERE (([id] = @Original_id) AND ([Class] = @Original_Class) AND ((@IsNull_TotalPoints = 1 AND [TotalPoints] IS NULL) OR ([TotalPoints] = @Original_TotalPoints)) AND ((@IsNull_AquiredPoints = 1 AND [AquiredPoints] IS NULL) OR ([AquiredPoints] = @Original_AquiredPoints)) AND ((@IsNull_OverallGrade = 1 AND [OverallGrade] IS NULL) OR ([OverallGrade] = @Original_OverallGrade)) AND ([Term] = @Original_Term) AND ((@IsNull_Instructor = 1 AND [Instructor] IS NULL) OR ([Instructor] = @Original_Instructor)) AND ((@IsNull_Credit = 1 AND [Credit] IS NULL) OR ([Credit] = @Original_Credit)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AquiredPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OverallGrade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OverallGrade" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblClass] ([Class], [TotalPoints], [AquiredPoints], [OverallGrade], [Term], [Instructor], [Credit]) VALUES (@Class, @TotalPoints, @AquiredPoints, @OverallGrade, @Term, @Instructor, @Credit);
SELECT id, Class, TotalPoints, AquiredPoints, OverallGrade, Term, Instructor, Credit FROM tblClass WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OverallGrade" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Class, TotalPoints, AquiredPoints, OverallGrade, Term, Instructor, Credit FROM dbo.tblClass</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblClass] SET [Class] = @Class, [TotalPoints] = @TotalPoints, [AquiredPoints] = @AquiredPoints, [OverallGrade] = @OverallGrade, [Term] = @Term, [Instructor] = @Instructor, [Credit] = @Credit WHERE (([id] = @Original_id) AND ([Class] = @Original_Class) AND ((@IsNull_TotalPoints = 1 AND [TotalPoints] IS NULL) OR ([TotalPoints] = @Original_TotalPoints)) AND ((@IsNull_AquiredPoints = 1 AND [AquiredPoints] IS NULL) OR ([AquiredPoints] = @Original_AquiredPoints)) AND ((@IsNull_OverallGrade = 1 AND [OverallGrade] IS NULL) OR ([OverallGrade] = @Original_OverallGrade)) AND ([Term] = @Original_Term) AND ((@IsNull_Instructor = 1 AND [Instructor] IS NULL) OR ([Instructor] = @Original_Instructor)) AND ((@IsNull_Credit = 1 AND [Credit] IS NULL) OR ([Credit] = @Original_Credit)));
SELECT id, Class, TotalPoints, AquiredPoints, OverallGrade, Term, Instructor, Credit FROM tblClass WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OverallGrade" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Term" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TotalPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AquiredPoints" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_AquiredPoints" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="AquiredPoints" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OverallGrade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OverallGrade" Precision="5" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="OverallGrade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Term" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Instructor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Instructor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Class" DataSetColumn="Class" />
              <Mapping SourceColumn="TotalPoints" DataSetColumn="TotalPoints" />
              <Mapping SourceColumn="AquiredPoints" DataSetColumn="AquiredPoints" />
              <Mapping SourceColumn="OverallGrade" DataSetColumn="OverallGrade" />
              <Mapping SourceColumn="Term" DataSetColumn="Term" />
              <Mapping SourceColumn="Instructor" DataSetColumn="Instructor" />
              <Mapping SourceColumn="Credit" DataSetColumn="Credit" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SchoolManagerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SchoolManagerDataSet" msprop:Generator_DataSetName="SchoolManagerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblAssignment" msprop:Generator_UserTableName="tblAssignment" msprop:Generator_RowDeletedName="tblAssignmentRowDeleted" msprop:Generator_RowChangedName="tblAssignmentRowChanged" msprop:Generator_RowClassName="tblAssignmentRow" msprop:Generator_RowChangingName="tblAssignmentRowChanging" msprop:Generator_RowEvArgName="tblAssignmentRowChangeEvent" msprop:Generator_RowEvHandlerName="tblAssignmentRowChangeEventHandler" msprop:Generator_TableClassName="tblAssignmentDataTable" msprop:Generator_TableVarName="tabletblAssignment" msprop:Generator_RowDeletingName="tblAssignmentRowDeleting" msprop:Generator_TablePropName="tblAssignment">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DueDate" msprop:Generator_UserColumnName="DueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Percent" msprop:Generator_UserColumnName="Percent" msprop:Generator_ColumnPropNameInRow="Percent" msprop:Generator_ColumnVarNameInTable="columnPercent" msprop:Generator_ColumnPropNameInTable="PercentColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Class" msprop:Generator_UserColumnName="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" type="xs:int" />
              <xs:element name="Kind" msprop:Generator_UserColumnName="Kind" msprop:Generator_ColumnVarNameInTable="columnKind" msprop:Generator_ColumnPropNameInRow="Kind" msprop:Generator_ColumnPropNameInTable="KindColumn" type="xs:int" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Complete" msprop:Generator_UserColumnName="Complete" msprop:Generator_ColumnVarNameInTable="columnComplete" msprop:Generator_ColumnPropNameInRow="Complete" msprop:Generator_ColumnPropNameInTable="CompleteColumn" type="xs:boolean" />
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblInstructor" msprop:Generator_UserTableName="tblInstructor" msprop:Generator_RowDeletedName="tblInstructorRowDeleted" msprop:Generator_RowChangedName="tblInstructorRowChanged" msprop:Generator_RowClassName="tblInstructorRow" msprop:Generator_RowChangingName="tblInstructorRowChanging" msprop:Generator_RowEvArgName="tblInstructorRowChangeEvent" msprop:Generator_RowEvHandlerName="tblInstructorRowChangeEventHandler" msprop:Generator_TableClassName="tblInstructorDataTable" msprop:Generator_TableVarName="tabletblInstructor" msprop:Generator_RowDeletingName="tblInstructorRowDeleting" msprop:Generator_TablePropName="tblInstructor">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNumber" msprop:Generator_UserColumnName="PhoneNumber" msprop:Generator_ColumnPropNameInRow="PhoneNumber" msprop:Generator_ColumnVarNameInTable="columnPhoneNumber" msprop:Generator_ColumnPropNameInTable="PhoneNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblGrades" msprop:Generator_UserTableName="tblGrades" msprop:Generator_RowDeletedName="tblGradesRowDeleted" msprop:Generator_RowChangedName="tblGradesRowChanged" msprop:Generator_RowClassName="tblGradesRow" msprop:Generator_RowChangingName="tblGradesRowChanging" msprop:Generator_RowEvArgName="tblGradesRowChangeEvent" msprop:Generator_RowEvHandlerName="tblGradesRowChangeEventHandler" msprop:Generator_TableClassName="tblGradesDataTable" msprop:Generator_TableVarName="tabletblGrades" msprop:Generator_RowDeletingName="tblGradesRowDeleting" msprop:Generator_TablePropName="tblGrades">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
              <xs:element name="Assignment" msprop:Generator_UserColumnName="Assignment" msprop:Generator_ColumnVarNameInTable="columnAssignment" msprop:Generator_ColumnPropNameInRow="Assignment" msprop:Generator_ColumnPropNameInTable="AssignmentColumn" type="xs:int" />
              <xs:element name="TotalPoints" msprop:Generator_UserColumnName="TotalPoints" msprop:Generator_ColumnVarNameInTable="columnTotalPoints" msprop:Generator_ColumnPropNameInRow="TotalPoints" msprop:Generator_ColumnPropNameInTable="TotalPointsColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="AquiredPoints" msprop:Generator_UserColumnName="AquiredPoints" msprop:Generator_ColumnVarNameInTable="columnAquiredPoints" msprop:Generator_ColumnPropNameInRow="AquiredPoints" msprop:Generator_ColumnPropNameInTable="AquiredPointsColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblKind" msprop:Generator_UserTableName="tblKind" msprop:Generator_RowDeletedName="tblKindRowDeleted" msprop:Generator_RowChangedName="tblKindRowChanged" msprop:Generator_RowClassName="tblKindRow" msprop:Generator_RowChangingName="tblKindRowChanging" msprop:Generator_RowEvArgName="tblKindRowChangeEvent" msprop:Generator_RowEvHandlerName="tblKindRowChangeEventHandler" msprop:Generator_TableClassName="tblKindDataTable" msprop:Generator_TableVarName="tabletblKind" msprop:Generator_RowDeletingName="tblKindRowDeleting" msprop:Generator_TablePropName="tblKind">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
              <xs:element name="Kind" msprop:Generator_UserColumnName="Kind" msprop:Generator_ColumnVarNameInTable="columnKind" msprop:Generator_ColumnPropNameInRow="Kind" msprop:Generator_ColumnPropNameInTable="KindColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPriority" msprop:Generator_UserTableName="tblPriority" msprop:Generator_RowDeletedName="tblPriorityRowDeleted" msprop:Generator_RowChangedName="tblPriorityRowChanged" msprop:Generator_RowClassName="tblPriorityRow" msprop:Generator_RowChangingName="tblPriorityRowChanging" msprop:Generator_RowEvArgName="tblPriorityRowChangeEvent" msprop:Generator_RowEvHandlerName="tblPriorityRowChangeEventHandler" msprop:Generator_TableClassName="tblPriorityDataTable" msprop:Generator_TableVarName="tabletblPriority" msprop:Generator_RowDeletingName="tblPriorityRowDeleting" msprop:Generator_TablePropName="tblPriority">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTerm" msprop:Generator_UserTableName="tblTerm" msprop:Generator_RowDeletedName="tblTermRowDeleted" msprop:Generator_RowChangedName="tblTermRowChanged" msprop:Generator_RowClassName="tblTermRow" msprop:Generator_RowChangingName="tblTermRowChanging" msprop:Generator_RowEvArgName="tblTermRowChangeEvent" msprop:Generator_RowEvHandlerName="tblTermRowChangeEventHandler" msprop:Generator_TableClassName="tblTermDataTable" msprop:Generator_TableVarName="tabletblTerm" msprop:Generator_RowDeletingName="tblTermRowDeleting" msprop:Generator_TablePropName="tblTerm">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
              <xs:element name="Term" msprop:Generator_UserColumnName="Term" msprop:Generator_ColumnVarNameInTable="columnTerm" msprop:Generator_ColumnPropNameInRow="Term" msprop:Generator_ColumnPropNameInTable="TermColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblClass" msprop:Generator_UserTableName="tblClass" msprop:Generator_RowDeletedName="tblClassRowDeleted" msprop:Generator_TableClassName="tblClassDataTable" msprop:Generator_RowChangedName="tblClassRowChanged" msprop:Generator_RowClassName="tblClassRow" msprop:Generator_RowChangingName="tblClassRowChanging" msprop:Generator_RowEvArgName="tblClassRowChangeEvent" msprop:Generator_RowEvHandlerName="tblClassRowChangeEventHandler" msprop:Generator_TablePropName="tblClass" msprop:Generator_TableVarName="tabletblClass" msprop:Generator_RowDeletingName="tblClassRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
              <xs:element name="Class" msprop:Generator_UserColumnName="Class" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInTable="ClassColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalPoints" msprop:Generator_UserColumnName="TotalPoints" msprop:Generator_ColumnPropNameInRow="TotalPoints" msprop:Generator_ColumnVarNameInTable="columnTotalPoints" msprop:Generator_ColumnPropNameInTable="TotalPointsColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="AquiredPoints" msprop:Generator_UserColumnName="AquiredPoints" msprop:Generator_ColumnPropNameInRow="AquiredPoints" msprop:Generator_ColumnVarNameInTable="columnAquiredPoints" msprop:Generator_ColumnPropNameInTable="AquiredPointsColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="OverallGrade" msprop:Generator_UserColumnName="OverallGrade" msprop:Generator_ColumnPropNameInRow="OverallGrade" msprop:Generator_ColumnVarNameInTable="columnOverallGrade" msprop:Generator_ColumnPropNameInTable="OverallGradeColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Term" msprop:Generator_UserColumnName="Term" msprop:Generator_ColumnPropNameInRow="Term" msprop:Generator_ColumnVarNameInTable="columnTerm" msprop:Generator_ColumnPropNameInTable="TermColumn" type="xs:int" />
              <xs:element name="Instructor" msprop:Generator_UserColumnName="Instructor" msprop:Generator_ColumnPropNameInRow="Instructor" msprop:Generator_ColumnVarNameInTable="columnInstructor" msprop:Generator_ColumnPropNameInTable="InstructorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Credit" msprop:Generator_UserColumnName="Credit" msprop:Generator_ColumnPropNameInRow="Credit" msprop:Generator_ColumnVarNameInTable="columnCredit" msprop:Generator_ColumnPropNameInTable="CreditColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignment" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="tblGrades_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblGrades" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblKind_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblKind" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblPriority_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblPriority" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblTerm_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTerm" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblClass_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblClass" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblAssignment_tblClass" msdata:parent="tblClass" msdata:child="tblAssignment" msdata:parentkey="id" msdata:childkey="Class" msprop:Generator_UserRelationName="FK_tblAssignment_tblClass" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblClass" msprop:Generator_UserChildTable="tblAssignment" msprop:Generator_UserParentTable="tblClass" msprop:Generator_ParentPropName="tblClassRow" msprop:Generator_ChildPropName="GettblAssignmentRows" />
      <msdata:Relationship name="FK_tblClass_tblTerm" msdata:parent="tblTerm" msdata:child="tblClass" msdata:parentkey="id" msdata:childkey="Term" msprop:Generator_UserRelationName="FK_tblClass_tblTerm" msprop:Generator_RelationVarName="relationFK_tblClass_tblTerm" msprop:Generator_UserChildTable="tblClass" msprop:Generator_UserParentTable="tblTerm" msprop:Generator_ParentPropName="tblTermRow" msprop:Generator_ChildPropName="GettblClassRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>